﻿CREATE PROCEDURE [dbo].[UpdateTimeEntry]
@EntryLogID INT, @UserID INT, @ProjectID INT, @CategoryID INT, @EntryDate DATETIME, @Description NVARCHAR (255), @Duration DECIMAL (10, 2), @OvernightStay BIT
AS
UPDATE
	 EntryLog
		SET 	
			UserID=@UserID,
		     	ProjectID = @ProjectID,
			CategoryID = @CategoryID,
			EntryDate = @EntryDate,
			Description = @Description,
			Duration = @Duration,
			OvernightStay = @OvernightStay
	       
WHERE 
	EntryLogID = @EntryLogID

